{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2025-10-13T12:28:04.746559Z",
     "start_time": "2025-10-13T12:28:04.727822Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import pandapower.networks as nw\n",
    "from pandapower.plotting.plotly.layers_plotly import layers_plotly"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2025-10-13T12:28:07.099837Z",
     "start_time": "2025-10-13T12:28:04.752389Z"
    },
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 804
    },
    "id": "7lZ-zMASzrJ-",
    "outputId": "89ee2d8a-4ee3-4890-ae26-9b8d3673ae5a"
   },
   "outputs": [],
   "source": [
    "net = nw.mv_oberrhein(\"generation\")\n",
    "\n",
    "cluster_bus = pd.read_excel(\"bus_groups_5.xlsx\", engine = 'openpyxl', index_col = 0)\n",
    "cluster_bus = cluster_bus.drop([\"bus*\"], axis = 1)\n",
    "\n",
    "layers_plotly(net, cluster_bus)"
   ]
  }
 ],
 "metadata": {
  "colab": {
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "name": "python"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}
